package com.wits.qso.dao.custom;

import java.util.Date;
import java.util.List;

import com.wits.qso.entity.Btable;
import com.wits.qso.entity.Cls;
import com.wits.qso.entity.Course;
import com.wits.qso.entity.Croom;
import com.wits.qso.entity.Dept;
import com.wits.qso.entity.Grade;
import com.wits.qso.entity.Teacher;

public interface BtableDaoCustom {
	
	public int deleteByCroom(String crmId);
	
	public Btable findByIdAndTeacher(String id, Teacher teacher);
	
	public List<Btable> findByCroom(String crmId);
	
	public List<Btable> findByCroom(String crmId,Date start,Date end) ;
	
	public List<Btable> findByCroomAndWeDay(String weday, String crmId);
	
	public List<Croom> findAliveCroom() ;
	
	public List<Btable> findByCroom(Croom room,String weday,String cla);
	
	public boolean isEixtClass(Cls cls,Date start,Date end);
	
	public List<Btable> findByParameter(Croom room,Course courId,
			Dept deptId,Teacher terId,Grade gradeId,Cls calId,String weday,String cal);
	
	public List<Btable> findIsSettedByCroom(Croom room);
	
	public List<Btable> findByTeacher(Teacher teacher);
	
	public List<Btable> findByclaId(Cls claId);
	
	public List<Btable> findByclaId(Cls claId,Date start,Date end);
	
	public List<Btable> findByclaIdAndCourseId(Cls claId,Course course);
	
	public Btable findByclaIdAndId(String id,Cls claId);
	
	public List<Btable> findByWedayAndClass(String weday,String cla,Croom room);
	
	public List<Btable> findByCroomAndWedayTF(Croom room,int wedayStart,int wedayEnd);
	
	public Btable findByCurrentTime(Date currentTime);
}
